/*
 Navicat Premium Data Transfer

 Source Server         : winform通用开发框架
 Source Server Type    : MySQL
 Source Server Version : 80035
 Source Host           : localhost:3306
 Source Schema         : winformdevelopframe

 Target Server Type    : MySQL
 Target Server Version : 80035
 File Encoding         : 65001

 Date: 04/01/2024 11:12:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sysconnect
-- ----------------------------
DROP TABLE IF EXISTS `sysconnect`;
CREATE TABLE `sysconnect`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ConnectName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '连接名称',
  `DbType` int NULL DEFAULT NULL COMMENT '数据库类型',
  `ConnectStr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '连接字符串',
  `Username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
  `Password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `Host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主机',
  `DbName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据库名称',
  `BId` int NULL DEFAULT NULL COMMENT 'BId',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysconnect
-- ----------------------------
BEGIN;
INSERT INTO `sysconnect` (`Id`, `ConnectName`, `DbType`, `ConnectStr`, `Username`, `Password`, `Host`, `DbName`, `BId`) VALUES (23, '本机', 1, 'Server=localhost;Database=winformdevelopframe;User Id = root; Password=root;', 'root', 'root', 'localhost', 'winformdevelopframe', 0);
COMMIT;

-- ----------------------------
-- Table structure for sysdatatable
-- ----------------------------
DROP TABLE IF EXISTS `sysdatatable`;
CREATE TABLE `sysdatatable`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DataTableName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据源名称',
  `SQL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据源Sql',
  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `BId` int NULL DEFAULT NULL,
  `ConnectId` int NULL DEFAULT NULL COMMENT '连接名称',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysdatatable
-- ----------------------------
BEGIN;
INSERT INTO `sysdatatable` (`Id`, `DataTableName`, `SQL`, `Remark`, `BId`, `ConnectId`) VALUES (1, '测试1', 'select * from sysdatatable;', '获取数据源列表', NULL, 0), (2, '菜单-treelistLookupedit', 'SELECT Id,PId,MenuText 菜单名称 FROM sysmenu', '热热完全', NULL, 0), (3, '用户-lookupedit', 'select Id,UserName 用户名称 from sysuser', '', NULL, 0), (4, '部门-tree', 'select Id,PId,deptname 部门名称 from sysdept', '', NULL, 0), (5, '角色-lookupedit', 'select Id,RoleName 角色名称 from sysrole', '', NULL, 0), (6, '字典类型', 'select Id,DicType 字典类型 from sysdictype', '', NULL, 0), (7, '数据库类型', 'SELECT Id, DicData 数据库类型 FROM sysdicdata where DicTypeId=1', '', NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sysdept
-- ----------------------------
DROP TABLE IF EXISTS `sysdept`;
CREATE TABLE `sysdept`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `PId` int NULL DEFAULT NULL COMMENT '上级部门',
  `BId` int NULL DEFAULT NULL COMMENT '数据ID',
  `DeptName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门名称',
  `DeptCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门编码',
  `DeptLXRId` int NULL DEFAULT NULL COMMENT '部门联系人',
  `DeptLeaderId` int NULL DEFAULT NULL COMMENT '部门负责人',
  `DeptAddress` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门地址',
  `DeptPhone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '部门电话',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysdept
-- ----------------------------
BEGIN;
INSERT INTO `sysdept` (`Id`, `PId`, `BId`, `DeptName`, `DeptCode`, `DeptLXRId`, `DeptLeaderId`, `DeptAddress`, `DeptPhone`, `CreateUserId`, `CreateTime`, `UpdateUserId`, `UpdateTime`) VALUES (1, -1, 1, 'Winform通用开发框架', 'Winfrom', NULL, NULL, NULL, NULL, 1, '2023-12-30 22:26:42', 1, '2023-12-30 22:26:45'), (2, 1, 0, 'IT', 'IT', 1, 1, '', '15029367414', 1, '2023-12-30 00:00:00', 0, '1900-01-01 00:00:00'), (4, 2, 0, 'ERP', 'ERP', 1, 4, '', '', 1, '2023-12-31 11:40:51', 0, '1900-01-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sysdicdata
-- ----------------------------
DROP TABLE IF EXISTS `sysdicdata`;
CREATE TABLE `sysdicdata`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DicTypeId` int NULL DEFAULT NULL COMMENT '字典类型',
  `DicData` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典数据',
  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysdicdata
-- ----------------------------
BEGIN;
INSERT INTO `sysdicdata` (`Id`, `DicTypeId`, `DicData`, `Remark`, `CreateUserId`, `CreateTime`, `UpdateUserId`, `UpdateTime`) VALUES (1, 1, 'MySql', '', 1, '2024-01-03 18:25:30', 0, '1900-01-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sysdictype
-- ----------------------------
DROP TABLE IF EXISTS `sysdictype`;
CREATE TABLE `sysdictype`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DicType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '字典类型',
  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysdictype
-- ----------------------------
BEGIN;
INSERT INTO `sysdictype` (`Id`, `DicType`, `Remark`, `CreateUserId`, `CreateTime`, `UpdateUserId`, `UpdateTime`) VALUES (1, '数据库类型', '', 1, '2024-01-03 18:08:53', 0, '1900-01-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for sysexceptionlog
-- ----------------------------
DROP TABLE IF EXISTS `sysexceptionlog`;
CREATE TABLE `sysexceptionlog`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `ExceptionContent` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '异常内容',
  `UserId` int NULL DEFAULT NULL COMMENT '用户',
  `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IP',
  `ExceptionTime` datetime NULL DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysexceptionlog
-- ----------------------------
BEGIN;
INSERT INTO `sysexceptionlog` (`Id`, `ExceptionContent`, `UserId`, `IP`, `ExceptionTime`) VALUES (1, 'The requested service \'Frmsysconnect (System.Windows.Forms.Form)\' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependency.\n\nSee https://autofac.rtfd.io/help/service-not-registered for more info.', 1, '2.0.0.1', '2024-01-04 10:25:26'), (2, 'Splash Form has already been displayed', 1, '2.0.0.1', '2024-01-04 10:25:38'), (3, 'The requested service \'Frmsysconnect (System.Windows.Forms.Form)\' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependency.\n\nSee https://autofac.rtfd.io/help/service-not-registered for more info.', 1, '2.0.0.1', '2024-01-04 10:27:00'), (4, 'Splash Form is not displayed', 1, '2.0.0.1', '2024-01-04 10:27:19'), (5, 'The requested service \'Frmsysconnect (System.Windows.Forms.Form)\' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependency.\n\nSee https://autofac.rtfd.io/help/service-not-registered for more info.', 1, '2.0.0.1', '2024-01-04 10:34:53'), (6, 'The requested service \'Frmsysconnect (System.Windows.Forms.Form)\' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependency.\n\nSee https://autofac.rtfd.io/help/service-not-registered for more info.', 1, '2.0.0.1', '2024-01-04 10:37:57');
COMMIT;

-- ----------------------------
-- Table structure for sysmenu
-- ----------------------------
DROP TABLE IF EXISTS `sysmenu`;
CREATE TABLE `sysmenu`  (
  `Id` int NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `BId` int NULL DEFAULT NULL COMMENT '数据ID',
  `PId` int NULL DEFAULT NULL COMMENT '父ID',
  `MenuText` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `MenuCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单编码',
  `MenuIcon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `MenuType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单类型',
  `MenuDll` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单地址',
  `IsExtendDevelop` bit(1) NULL DEFAULT NULL COMMENT '是否扩展开发',
  `MenuName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单类名',
  `IsPublicFunction` bit(1) NULL DEFAULT NULL COMMENT '是否通用功能',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `OrderNo` int NULL DEFAULT NULL COMMENT '排序',
  `ShowType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'TabShow' COMMENT '显示方式',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysmenu
-- ----------------------------
BEGIN;
INSERT INTO `sysmenu` (`Id`, `BId`, `PId`, `MenuText`, `MenuCode`, `MenuIcon`, `MenuType`, `MenuDll`, `IsExtendDevelop`, `MenuName`, `IsPublicFunction`, `CreateUserId`, `CreateTime`, `UpdateUserId`, `UpdateTime`, `Remark`, `OrderNo`, `ShowType`) VALUES (1, 1, -1, '通用开发框架', 'DevelopFrame', 'Images\\UI\\Window_32x32.png', 'Root', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '根目录', NULL, NULL), (2, 1, 34, '代码生成', 'FrmGeneratedCode', 'Images\\Programming\\CSharp_32x32.png', 'Form', '', b'0', 'FrmGeneratedCode', b'0', 0, '2023-12-29 16:14:39', 1, '2023-12-31 12:12:44', '代码生成', 1, NULL), (3, 1, 1, '系统管理', 'SystemManager', 'Images\\Setup\\Properties_32x32.png', 'Page', '', b'0', '', b'0', 0, '2023-12-29 00:00:00', 0, '2023-12-29 00:00:00', '', NULL, NULL), (4, 1, 3, '基础数据', 'SystemBaseData', 'Images\\Data\\CreateModelDifferences_32x32.png', 'Group', '', b'0', '', b'0', 0, '2023-12-29 00:00:00', 0, '2023-12-30 00:00:00', '', NULL, NULL), (5, 1, 4, '菜单设置', 'Frmsysmenu', 'Images\\XAF\\Context_Menu_Show_In_Popup32x32.png', 'Form', '', b'0', 'Frmsysmenu', b'0', 0, '2023-12-29 19:37:52', 0, '2023-12-29 19:37:54', '菜单设置', NULL, NULL), (7, 0, 5, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 00:00:00', 0, '2023-12-29 00:00:00', '', 1, NULL), (8, 0, 5, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 21:29:12', 0, '2023-12-29 21:29:14', '', 3, NULL), (9, 0, 5, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 21:30:14', 0, '2023-12-29 21:30:17', '', 6, NULL), (10, 0, 5, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 00:00:00', 0, '2023-12-29 00:00:00', '', 2, NULL), (11, 0, 5, '撤销', 'btnCancel', 'Images\\XAF\\Action_Cancel.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 00:00:00', 0, '2023-12-29 00:00:00', '', 4, NULL), (12, 0, 5, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'1', 0, '2023-12-29 00:00:00', 0, '2023-12-29 00:00:00', '', 5, NULL), (13, 0, 4, '用户管理', 'Frmsysuser', 'Images\\People\\UserGroup_32x32.png', 'Form', '', b'0', 'Frmsysuser', b'0', 0, '2024-01-05 00:00:00', 0, '2023-12-30 00:00:00', '', 1, NULL), (14, 0, 13, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 1, '2023-12-31 11:49:05', '', 1, NULL), (15, 0, 13, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 0, '2023-12-30 00:00:00', '', 3, NULL), (16, 0, 13, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 0, '2023-12-30 00:00:00', '', 2, NULL), (17, 0, 34, '数据源设置', 'Frmsysdatatable', 'Images\\Data\\AddNewDataSource_32x32.png', 'Form', '', b'0', 'Frmsysdatatable', b'0', 0, '2023-12-30 00:00:00', 1, '2023-12-31 12:07:56', '', 1, NULL), (18, 0, 17, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 0, '2023-12-30 00:00:00', '', 0, NULL), (19, 0, 17, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 0, '2023-12-30 00:00:00', '', 0, NULL), (20, 0, 17, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 0, '2023-12-30 00:00:00', 0, '2023-12-30 00:00:00', '', 0, NULL), (21, 0, 4, '部门管理', 'Frmsysdept', 'Images\\Business Objects\\BOCountry_32x32.png', 'Form', '', b'0', 'Frmsysdept', b'0', 1, '2023-12-30 21:54:14', 0, '1900-01-01 00:00:00', '', 0, NULL), (22, 0, 21, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-30 22:08:04', 0, '1900-01-01 00:00:00', '', 0, NULL), (23, 0, 21, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-30 22:09:46', 1, '2023-12-30 22:34:23', '', 0, NULL), (24, 0, 21, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-30 22:10:36', 0, '1900-01-01 00:00:00', '', 0, NULL), (25, 0, 17, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:32:37', 0, '1900-01-01 00:00:00', '', 0, NULL), (26, 0, 17, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:35:48', 0, '1900-01-01 00:00:00', '', 0, NULL), (27, 0, 17, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:36:25', 0, '1900-01-01 00:00:00', '', 0, NULL), (28, 0, 13, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:37:15', 1, '2023-12-31 11:49:50', '', 4, NULL), (29, 0, 13, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:37:50', 1, '2023-12-31 11:50:04', '', 5, NULL), (30, 0, 13, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:38:22', 1, '2023-12-31 11:50:19', '', 6, NULL), (31, 0, 21, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:39:17', 0, '1900-01-01 00:00:00', '', 0, NULL), (32, 0, 21, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:40:00', 0, '1900-01-01 00:00:00', '', 0, NULL), (33, 0, 21, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 11:40:23', 0, '1900-01-01 00:00:00', '', 0, NULL), (34, 0, 3, '代码生成', 'CodeCreate', 'Images\\Programming\\CSharp_32x32.png', 'Group', '', b'0', '', b'0', 1, '2023-12-31 12:06:20', 0, '1900-01-01 00:00:00', '', 0, NULL), (35, 0, 3, '系统设置', 'SystemSetup', 'Images\\Setup\\Properties_16x16.png', 'Group', '', b'0', '', b'0', 1, '2023-12-31 12:18:29', 0, '1900-01-01 00:00:00', '', 0, NULL), (38, 0, 35, '更换皮肤', 'FrmSkin', 'Images\\XAF\\Action_EditModel_32x32.png', 'Form', '', b'0', 'FrmSkin', b'0', 1, '2023-12-31 12:50:25', 1, '2023-12-31 12:55:01', '', 0, 'ShowDialog'), (39, 0, 4, '角色管理', 'Frmsysrole', 'Images\\People\\Role_32x32.png', 'Form', '', b'0', 'Frmsysrole', b'0', 1, '2023-12-31 14:00:10', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (40, 0, 39, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:01:02', 0, '1900-01-01 00:00:00', '', 0, ''), (41, 0, 39, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:01:26', 0, '1900-01-01 00:00:00', '', 0, ''), (42, 0, 39, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:01:56', 0, '1900-01-01 00:00:00', '', 0, ''), (43, 0, 39, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:02:25', 0, '1900-01-01 00:00:00', '', 0, ''), (44, 0, 39, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:02:57', 0, '1900-01-01 00:00:00', '', 0, ''), (45, 0, 39, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 14:03:19', 0, '1900-01-01 00:00:00', '', 0, ''), (46, 0, 35, '在线用户', 'FrmUserStatus', 'Images\\People\\User_32x32.png', 'Form', '', b'0', 'FrmUserStatus', b'0', 1, '2023-12-31 20:40:12', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (47, 0, 46, '强制下线', 'btnLogout', 'Images\\Chart\\DrillDown_16x16.png', 'Button', '', b'0', '', b'1', 1, '2023-12-31 20:43:02', 0, '1900-01-01 00:00:00', '', 0, ''), (48, 0, 46, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2023-12-31 21:08:59', 0, '1900-01-01 00:00:00', '', 0, ''), (49, 0, 3, '日志管理', 'Log', 'Images\\Function Library\\Logical_32x32.png', 'Group', '', b'0', '', b'0', 1, '2024-01-01 14:51:29', 0, '1900-01-01 00:00:00', '', 0, ''), (50, 0, 49, '用户日志', 'Frmsysuserlog', 'Images\\Function Library\\Logical_32x32.png', 'Form', '', b'0', 'Frmsysuserlog', b'0', 1, '2024-01-01 14:52:49', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (51, 0, 50, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-01 14:53:32', 0, '1900-01-01 00:00:00', '', 0, ''), (52, 0, 49, '异常日志', 'Frmsysexceptionlog', 'Images\\Status\\Warning_32x32.png', 'Form', '', b'0', 'Frmsysexceptionlog', b'0', 1, '2024-01-01 14:53:58', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (53, 0, 52, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-01 14:55:42', 0, '1900-01-01 00:00:00', '', 0, ''), (54, 0, 35, '修改密码', 'FrmUpdatePassword', 'Images\\RichEdit\\UpdateField_32x32.png', 'Form', '', b'0', 'FrmUpdatePassword', b'0', 1, '2024-01-01 15:53:34', 0, '1900-01-01 00:00:00', '', 0, 'ShowDialog'), (55, 0, 35, '流程', 'FromFlow', 'Images\\Layout\\FlowLayout_32x32.png', 'Form', '', b'0', 'FromFlow', b'0', 1, '2024-01-02 18:13:23', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (56, 0, 55, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-02 21:24:58', 0, '1900-01-01 00:00:00', '', 0, ''), (62, 0, 4, '字典类型', 'Frmsysdictype', 'Images\\Function Library\\MoreFunctions_32x32.png', 'Form', '', b'0', 'Frmsysdictype', b'0', 1, '2024-01-03 17:52:28', 0, '1900-01-01 00:00:00', '', 0, 'TabShow'), (63, 0, 62, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:00:29', 0, '1900-01-01 00:00:00', '', 0, ''), (64, 0, 62, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:01:29', 0, '1900-01-01 00:00:00', '', 0, ''), (65, 0, 62, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:01:58', 0, '1900-01-01 00:00:00', '', 0, ''), (66, 0, 62, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:02:37', 0, '1900-01-01 00:00:00', '', 0, ''), (67, 0, 62, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:03:05', 0, '1900-01-01 00:00:00', '', 0, ''), (68, 0, 62, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:04:01', 0, '1900-01-01 00:00:00', '', 0, ''), (69, 0, 4, '字典数据', 'Frmsysdicdata', 'Images\\Function Library\\Lookup&Reference_32x32.png', 'Form', '', b'0', 'Frmsysdicdata', b'0', 1, '2024-01-03 18:18:11', 1, '2024-01-03 18:24:00', '', 0, 'TabShow'), (70, 0, 69, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:19:08', 0, '1900-01-01 00:00:00', '', 0, ''), (71, 0, 69, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:19:53', 0, '1900-01-01 00:00:00', '', 0, ''), (72, 0, 69, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:20:21', 0, '1900-01-01 00:00:00', '', 0, ''), (73, 0, 69, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:20:51', 0, '1900-01-01 00:00:00', '', 0, ''), (74, 0, 69, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:21:37', 0, '1900-01-01 00:00:00', '', 0, ''), (75, 0, 69, '关闭', 'btnClose', 'Images\\Actions\\Close_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-03 18:22:02', 0, '1900-01-01 00:00:00', '', 0, ''), (76, 0, 34, '数据库连接设置', 'Frmsysconnect', 'Images\\Data\\ManageDatasource_32x32.png', 'Form', '', b'0', 'Frmsysconnect', b'0', 1, '2024-01-04 10:05:39', 1, '2024-01-04 10:58:22', '', 0, 'TabShow'), (77, 0, 76, '新增', 'btnAdd', 'Images\\Actions\\Add_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-04 10:06:29', 0, '1900-01-01 00:00:00', '', 0, ''), (78, 0, 76, '编辑', 'btnEdit', 'Images\\Edit\\Edit_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-04 10:06:54', 0, '1900-01-01 00:00:00', '', 0, ''), (79, 0, 76, '保存', 'btnSave', 'Images\\Save\\Save_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-04 10:07:22', 0, '1900-01-01 00:00:00', '', 0, ''), (80, 0, 76, '撤销', 'btnCancel', 'Images\\Actions\\Reset_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-04 10:07:49', 0, '1900-01-01 00:00:00', '', 0, ''), (81, 0, 76, '删除', 'btnDel', 'Images\\Actions\\DeleteList_16x16.png', 'Button', '', b'0', '', b'0', 1, '2024-01-04 10:08:21', 0, '1900-01-01 00:00:00', '', 0, '');
COMMIT;

-- ----------------------------
-- Table structure for sysrole
-- ----------------------------
DROP TABLE IF EXISTS `sysrole`;
CREATE TABLE `sysrole`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `RoleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色名称',
  `RoleCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '角色编码',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `Remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `BId` int NULL DEFAULT NULL COMMENT '数据Id',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysrole
-- ----------------------------
BEGIN;
INSERT INTO `sysrole` (`Id`, `RoleName`, `RoleCode`, `CreateUserId`, `Remark`, `CreateTime`, `UpdateUserId`, `UpdateTime`, `BId`) VALUES (1, '管理员', 'admin', 1, '', '2023-12-31 14:04:07', 1, '2024-01-04 10:08:51', NULL), (2, '游客', 'View', 1, '', '2024-01-01 15:56:32', 1, '2024-01-01 16:09:51', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sysrolemenu
-- ----------------------------
DROP TABLE IF EXISTS `sysrolemenu`;
CREATE TABLE `sysrolemenu`  (
  `RoleId` int NULL DEFAULT NULL COMMENT '角色Id',
  `MenuId` int NULL DEFAULT NULL COMMENT '功能Id'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysrolemenu
-- ----------------------------
BEGIN;
INSERT INTO `sysrolemenu` (`RoleId`, `MenuId`) VALUES (0, 1), (0, 3), (0, 35), (0, 38), (2, 1), (2, 3), (2, 35), (2, 38), (2, 54), (1, 1), (1, 3), (1, 4), (1, 5), (1, 7), (1, 8), (1, 9), (1, 10), (1, 11), (1, 12), (1, 13), (1, 14), (1, 15), (1, 16), (1, 28), (1, 29), (1, 30), (1, 21), (1, 22), (1, 23), (1, 24), (1, 31), (1, 32), (1, 33), (1, 39), (1, 40), (1, 41), (1, 42), (1, 43), (1, 44), (1, 45), (1, 62), (1, 63), (1, 64), (1, 65), (1, 66), (1, 67), (1, 68), (1, 69), (1, 70), (1, 71), (1, 72), (1, 73), (1, 74), (1, 75), (1, 76), (1, 77), (1, 78), (1, 79), (1, 80), (1, 81), (1, 34), (1, 2), (1, 17), (1, 18), (1, 19), (1, 20), (1, 25), (1, 26), (1, 27), (1, 35), (1, 38), (1, 46), (1, 47), (1, 48), (1, 54), (1, 55), (1, 56), (1, 49), (1, 50), (1, 51), (1, 52), (1, 53);
COMMIT;

-- ----------------------------
-- Table structure for sysuser
-- ----------------------------
DROP TABLE IF EXISTS `sysuser`;
CREATE TABLE `sysuser`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `BId` int NULL DEFAULT NULL COMMENT '数据ID',
  `UserName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
  `LoginAccount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登陆账号',
  `Password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `Iphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话',
  `Address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '地址',
  `DeptId` int NULL DEFAULT NULL COMMENT '部门',
  `LeaderId` int NULL DEFAULT NULL COMMENT '直接领导',
  `Status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',
  `Sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
  `Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '邮箱',
  `LoginLastTime` datetime NULL DEFAULT NULL COMMENT '最后登录事件',
  `RoleId` int NULL DEFAULT NULL COMMENT '角色',
  `CreateUserId` int NULL DEFAULT NULL COMMENT '创建人',
  `CreateTime` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UpdateUserId` int NULL DEFAULT NULL COMMENT '修改人',
  `UpdateTime` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `LoginStatus` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录状态',
  `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登录IP',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysuser
-- ----------------------------
BEGIN;
INSERT INTO `sysuser` (`Id`, `BId`, `UserName`, `LoginAccount`, `Password`, `Iphone`, `Address`, `DeptId`, `LeaderId`, `Status`, `Sex`, `Email`, `LoginLastTime`, `RoleId`, `CreateUserId`, `CreateTime`, `UpdateUserId`, `UpdateTime`, `LoginStatus`, `IP`) VALUES (1, 0, '管理员', 'admin', 'admin', '15029367414', '陕西省', 4, 0, '可用', '男', '648428741@qq.com', '2024-01-04 11:08:43', 1, 0, '2023-12-30 00:00:00', 1, '2024-01-02 22:39:16', '离线', '2.0.0.1'), (3, 0, '测试', 'test', '123456', '15029367414', '', 4, 1, '可用', '男', '', '2024-01-01 16:39:03', 2, 1, '2023-12-30 21:26:02', 1, '2024-01-01 16:09:09', '离线', '2.0.0.1');
COMMIT;

-- ----------------------------
-- Table structure for sysuserlog
-- ----------------------------
DROP TABLE IF EXISTS `sysuserlog`;
CREATE TABLE `sysuserlog`  (
  `Id` int NOT NULL AUTO_INCREMENT,
  `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'IP',
  `UserId` int NULL DEFAULT NULL COMMENT '用户',
  `Form` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务界面',
  `Action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '行为',
  `ViewTime` datetime NULL DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 234 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sysuserlog
-- ----------------------------
BEGIN;
INSERT INTO `sysuserlog` (`Id`, `IP`, `UserId`, `Form`, `Action`, `ViewTime`) VALUES (1, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 14:51:29'), (2, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 14:52:45'), (3, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 14:52:49'), (4, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 14:53:30'), (5, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 14:53:32'), (6, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 14:53:56'), (7, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 14:53:58'), (8, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 14:55:40'), (9, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 14:55:42'), (10, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 14:56:03'), (11, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-01 14:56:10'), (12, '2.0.0.1', 1, '角色管理', '保存', '2024-01-01 14:56:18'), (13, '2.0.0.1', 1, '在线用户', '关闭', '2024-01-01 15:05:28'), (14, '2.0.0.1', 1, '在线用户', '关闭', '2024-01-01 15:05:30'), (15, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 15:06:05'), (16, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-01 15:06:06'), (17, '2.0.0.1', 1, '用户日志', '关闭', '2024-01-01 15:06:21'), (18, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-01 15:06:35'), (19, '2.0.0.1', 1, '异常日志', '关闭', '2024-01-01 15:06:36'), (20, '2.0.0.1', 1, '部门管理', '关闭', '2024-01-01 15:06:39'), (21, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 15:11:33'), (22, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-01 15:11:34'), (23, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-01 15:53:34'), (24, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-01 15:54:49'), (25, '2.0.0.1', 1, '角色管理', '新增', '2024-01-01 15:54:53'), (26, '2.0.0.1', 1, '角色管理', '关闭', '2024-01-01 15:54:56'), (27, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-01 15:55:06'), (28, '2.0.0.1', 1, '角色管理', '保存', '2024-01-01 15:55:06'), (29, '2.0.0.1', 1, '角色管理', '新增', '2024-01-01 15:56:31'), (30, '2.0.0.1', 1, '角色管理', '保存', '2024-01-01 15:57:15'), (31, '2.0.0.1', 1, '用户管理', '新增', '2024-01-01 15:57:22'), (32, '2.0.0.1', 1, '用户管理', '保存', '2024-01-01 15:57:39'), (33, '2.0.0.1', 1, '用户管理', '保存', '2024-01-01 15:57:46'), (34, '2.0.0.1', 1, '用户管理', '关闭', '2024-01-01 15:57:48'), (35, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 15:58:27'), (36, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 15:58:28'), (37, '2.0.0.1', 3, '用户管理', '删除', '2024-01-01 15:59:25'), (38, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 15:59:28'), (39, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 15:59:32'), (40, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 16:00:17'), (41, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 16:00:18'), (42, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 16:00:20'), (43, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 16:00:23'), (44, '2.0.0.1', 3, '用户管理', '关闭', '2024-01-01 16:00:26'), (45, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 16:02:57'), (46, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 16:02:59'), (47, '2.0.0.1', 3, '用户管理', '关闭', '2024-01-01 16:03:01'), (48, '2.0.0.1', 3, '用户管理', '编辑', '2024-01-01 16:03:34'), (49, '2.0.0.1', 3, '用户管理', '保存', '2024-01-01 16:03:40'), (50, '2.0.0.1', 1, '用户管理', '编辑', '2024-01-01 16:09:09'), (51, '2.0.0.1', 1, '用户管理', '保存', '2024-01-01 16:09:12'), (52, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-01 16:09:51'), (53, '2.0.0.1', 1, '角色管理', '保存', '2024-01-01 16:09:59'), (54, '2.0.0.1', 1, '角色管理', '关闭', '2024-01-01 16:10:01'), (55, '2.0.0.1', 1, '用户日志', '关闭', '2024-01-02 18:13:21'), (56, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-02 18:13:23'), (57, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-02 18:13:59'), (58, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-02 18:14:08'), (59, '2.0.0.1', 1, '角色管理', '保存', '2024-01-02 18:14:09'), (60, '2.0.0.1', 1, '数据源设置', '关闭', '2024-01-02 21:02:13'), (61, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-02 21:24:58'), (62, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-02 21:25:25'), (63, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-02 21:47:30'), (64, '2.0.0.1', 1, '用户管理', '编辑', '2024-01-02 22:39:16'), (65, '2.0.0.1', 1, '用户管理', '保存', '2024-01-02 22:39:22'), (66, '2.0.0.1', 1, '用户管理', '关闭', '2024-01-02 22:50:52'), (67, '2.0.0.1', 1, '角色管理', '关闭', '2024-01-02 22:50:55'), (68, '2.0.0.1', 1, '用户管理', '关闭', '2024-01-03 09:42:25'), (69, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 15:50:39'), (70, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:25:13'), (71, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 16:26:03'), (72, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:26:09'), (73, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 16:26:26'), (74, '2.0.0.1', 1, '角色管理', '新增', '2024-01-03 16:26:28'), (75, '2.0.0.1', 1, '角色管理', '关闭', '2024-01-03 16:26:30'), (76, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-03 16:26:34'), (77, '2.0.0.1', 1, '角色管理', '保存', '2024-01-03 16:26:39'), (78, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:49:43'), (79, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:55:24'), (80, '2.0.0.1', 1, '菜单设置', '撤销', '2024-01-03 16:56:09'), (81, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:57:00'), (82, '2.0.0.1', 1, '菜单设置', '撤销', '2024-01-03 16:57:34'), (83, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:57:37'), (84, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-03 16:57:47'), (85, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 16:59:14'), (86, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:02:14'), (87, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:03:30'), (88, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:24:29'), (89, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:25:15'), (90, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:25:20'), (91, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:25:21'), (92, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:25:57'), (93, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:27:41'), (94, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:27:47'), (95, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:27:50'), (96, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:28:08'), (97, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:28:09'), (98, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:28:17'), (99, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:29:29'), (100, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-03 17:29:34'), (101, '2.0.0.1', 1, '菜单设置', '删除', '2024-01-03 17:29:40'), (102, '2.0.0.1', 1, '菜单设置', '删除', '2024-01-03 17:29:44'), (103, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-03 17:29:55'), (104, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:30:18'), (105, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:30:47'), (106, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:30:50'), (107, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:30:55'), (108, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:31:02'), (109, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:31:37'), (110, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:32:41'), (111, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:32:43'), (112, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:32:46'), (113, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-03 17:33:09'), (114, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-03 17:33:21'), (115, '2.0.0.1', 1, '角色管理', '保存', '2024-01-03 17:33:21'), (116, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 17:36:27'), (117, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:36:42'), (118, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:41:11'), (119, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:45:51'), (120, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 17:52:28'), (121, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:57:24'), (122, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 17:59:32'), (123, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:00:24'), (124, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:00:29'), (125, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:01:27'), (126, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:01:29'), (127, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:01:56'), (128, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:01:58'), (129, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:02:32'), (130, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:02:37'), (131, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:03:03'), (132, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:03:05'), (133, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:03:59'), (134, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:04:01'), (135, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:04:36'), (136, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-03 18:05:45'), (137, '2.0.0.1', 1, '角色管理', '保存', '2024-01-03 18:05:53'), (138, '2.0.0.1', 1, '字典类型', '新增', '2024-01-03 18:08:53'), (139, '2.0.0.1', 1, '字典类型', '保存', '2024-01-03 18:09:03'), (140, '2.0.0.1', 1, '菜单设置', '删除', '2024-01-03 18:09:36'), (141, '2.0.0.1', 1, '菜单设置', '删除', '2024-01-03 18:09:45'), (142, '2.0.0.1', 1, '菜单设置', '删除', '2024-01-03 18:09:52'), (143, '2.0.0.1', 1, '数据源设置', '新增', '2024-01-03 18:10:20'), (144, '2.0.0.1', 1, '数据源设置', '保存', '2024-01-03 18:11:25'), (145, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:18:10'), (146, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:19:05'), (147, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:19:08'), (148, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:19:46'), (149, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:19:53'), (150, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:20:19'), (151, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:20:21'), (152, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:20:49'), (153, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:20:51'), (154, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:21:35'), (155, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:21:37'), (156, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:22:01'), (157, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-03 18:22:02'), (158, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:22:39'), (159, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-03 18:22:43'), (160, '2.0.0.1', 1, '角色管理', '保存', '2024-01-03 18:22:47'), (161, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-03 18:24:00'), (162, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-03 18:24:01'), (163, '2.0.0.1', 1, '菜单设置', '关闭', '2024-01-03 18:24:04'), (164, '2.0.0.1', 1, '字典类型', '新增', '2024-01-03 18:24:38'), (165, '2.0.0.1', 1, 'sysdicdata', '关闭', '2024-01-03 18:24:43'), (166, '2.0.0.1', 1, '字典类型', '关闭', '2024-01-03 18:24:44'), (167, '2.0.0.1', 1, '字典数据', '新增', '2024-01-03 18:25:29'), (168, '2.0.0.1', 1, '字典数据', '保存', '2024-01-03 18:26:03'), (169, '2.0.0.1', 1, '字典数据', '新增', '2024-01-03 18:26:06'), (170, '2.0.0.1', 1, '字典数据', '保存', '2024-01-03 18:26:15'), (171, '2.0.0.1', 1, '字典数据', '新增', '2024-01-03 18:26:17'), (172, '2.0.0.1', 1, '字典数据', '保存', '2024-01-03 18:26:25'), (173, '2.0.0.1', 1, '字典数据', '新增', '2024-01-03 18:26:27'), (174, '2.0.0.1', 1, '字典数据', '撤销', '2024-01-03 18:26:31'), (175, '2.0.0.1', 1, '字典数据', '编辑', '2024-01-03 18:26:33'), (176, '2.0.0.1', 1, '字典数据', '撤销', '2024-01-03 18:26:34'), (177, '2.0.0.1', 1, '字典数据', '删除', '2024-01-03 18:26:35'), (178, '2.0.0.1', 1, '字典数据', '关闭', '2024-01-03 18:26:38'), (179, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 09:17:42'), (180, '2.0.0.1', 1, '在线用户', '强制下线', '2024-01-04 09:46:34'), (181, '2.0.0.1', 1, '在线用户', '强制下线', '2024-01-04 09:46:36'), (182, '2.0.0.1', 1, '在线用户', '强制下线', '2024-01-04 09:46:48'), (183, '2.0.0.1', 1, '在线用户', '关闭', '2024-01-04 09:46:52'), (184, '2.0.0.1', 1, '在线用户', '强制下线', '2024-01-04 09:46:55'), (185, '2.0.0.1', 1, '在线用户', '强制下线', '2024-01-04 09:46:57'), (186, '2.0.0.1', 1, '数据源设置', '新增', '2024-01-04 09:48:31'), (187, '2.0.0.1', 1, '数据源设置', '保存', '2024-01-04 09:50:51'), (188, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:05:38'), (189, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:06:22'), (190, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:06:29'), (191, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:06:52'), (192, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:06:54'), (193, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:07:20'), (194, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:07:22'), (195, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:07:47'), (196, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:07:49'), (197, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:08:18'), (198, '2.0.0.1', 1, '菜单设置', '新增', '2024-01-04 10:08:21'), (199, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:08:44'), (200, '2.0.0.1', 1, '角色管理', '编辑', '2024-01-04 10:08:51'), (201, '2.0.0.1', 1, '角色管理', '保存', '2024-01-04 10:09:01'), (202, '2.0.0.1', 1, '数据库连接设置', '新增', '2024-01-04 10:09:35'), (203, '2.0.0.1', 1, '数据源设置', '编辑', '2024-01-04 10:38:23'), (204, '2.0.0.1', 1, '数据源设置', '保存', '2024-01-04 10:38:23'), (205, '2.0.0.1', 1, 'sysconnect', '编辑', '2024-01-04 10:40:46'), (206, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:40:47'), (207, '2.0.0.1', 1, 'sysconnect', '撤销', '2024-01-04 10:40:55'), (208, '2.0.0.1', 1, 'sysconnect', '编辑', '2024-01-04 10:42:19'), (209, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:42:19'), (210, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:42:21'), (211, '2.0.0.1', 1, 'sysconnect', '撤销', '2024-01-04 10:42:27'), (212, '2.0.0.1', 1, 'sysconnect', '编辑', '2024-01-04 10:42:34'), (213, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:42:34'), (214, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:44:26'), (215, '2.0.0.1', 1, 'sysconnect', '保存', '2024-01-04 10:45:12'), (216, '2.0.0.1', 1, '数据库连接设置', '新增', '2024-01-04 10:52:36'), (217, '2.0.0.1', 1, '数据库连接设置', '保存', '2024-01-04 10:55:21'), (218, '2.0.0.1', 1, '数据库连接设置', '保存', '2024-01-04 10:55:40'), (219, '2.0.0.1', 1, '数据库连接设置', '编辑', '2024-01-04 10:56:12'), (220, '2.0.0.1', 1, '数据库连接设置', '保存', '2024-01-04 10:56:13'), (221, '2.0.0.1', 1, '数据库连接设置', '保存', '2024-01-04 10:56:22'), (222, '2.0.0.1', 1, '数据库连接设置', '撤销', '2024-01-04 10:56:28'), (223, '2.0.0.1', 1, '数据库连接设置', '编辑', '2024-01-04 10:56:35'), (224, '2.0.0.1', 1, '数据库连接设置', '撤销', '2024-01-04 10:56:36'), (225, '2.0.0.1', 1, '数据库连接设置', '删除', '2024-01-04 10:56:37'), (226, '2.0.0.1', 1, '数据库连接设置', '编辑', '2024-01-04 10:56:42'), (227, '2.0.0.1', 1, '数据库连接设置', '保存', '2024-01-04 10:56:43'), (228, '2.0.0.1', 1, '菜单设置', '编辑', '2024-01-04 10:58:22'), (229, '2.0.0.1', 1, '菜单设置', '保存', '2024-01-04 10:58:30'), (230, '2.0.0.1', 1, '字典数据', '编辑', '2024-01-04 10:58:48'), (231, '2.0.0.1', 1, '字典数据', '撤销', '2024-01-04 10:58:54'), (232, '2.0.0.1', 1, '字典数据', '删除', '2024-01-04 10:58:54'), (233, '2.0.0.1', 1, '字典数据', '关闭', '2024-01-04 10:58:56');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
